CREATE TABLE [dbo].[Events] (
    [ID]             INT            IDENTITY (1, 1) NOT NULL,
    [SubjectID]      INT            NULL,
    [EventStartTime] DATETIME       NOT NULL,
    [EventEndTime]   DATETIME       NOT NULL,
    [LetureRoom]     NVARCHAR (50)  NULL,
    [PersonID]       INT            NOT NULL,
    [BuildingID]     INT            NULL,
    [EventTypeID]    INT            NOT NULL,
    [IsClass]        BIT            NOT NULL,
    [Description]    NVARCHAR (250) NULL,
    [ScheduleID]     INT            NOT NULL,
    [rec_type]       NVARCHAR (50)  NULL,
    [event_length]   INT            NULL,
    [event_pid]      NVARCHAR (50)  NULL
);









